SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweAlumnoDivision
AS
SELECT     idRelDivisionAlumno AS ID, Alumno, AnioLectivo, Baja, Desde, Hasta, CausaBaja, previas
FROM         dbo.tb_AlumnoDivision
GO
GRANT SELECT ON  [dbo].[vweAlumnoDivision] TO [Alumnos]
GRANT INSERT ON  [dbo].[vweAlumnoDivision] TO [Alumnos]
GRANT DELETE ON  [dbo].[vweAlumnoDivision] TO [Alumnos]
GRANT UPDATE ON  [dbo].[vweAlumnoDivision] TO [Alumnos]
GRANT SELECT ON  [dbo].[vweAlumnoDivision] TO [Coordinaciones]
GRANT SELECT ON  [dbo].[vweAlumnoDivision] TO [GestionInstitucional]
GRANT INSERT ON  [dbo].[vweAlumnoDivision] TO [GestionInstitucional]
GRANT UPDATE ON  [dbo].[vweAlumnoDivision] TO [GestionInstitucional]
GRANT SELECT ON  [dbo].[vweAlumnoDivision] TO [Informatica]
GRANT INSERT ON  [dbo].[vweAlumnoDivision] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweAlumnoDivision] TO [Informatica]
GRANT SELECT ON  [dbo].[vweAlumnoDivision] TO [SoloVer]
GO
